<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<%@page import="java.util.*"%>
<%@ page import="java.net.URLEncoder"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<jsp:useBean id="db" class="ctm.javacode.dbBean" />

<html>
<head>

</head>
<body>
	<%
		/******設定******/
		response.setContentType("text/html");
		response.setCharacterEncoding("UTF-8");
		db.setDataSource("jdbc/ctmpllab");
		db.Connected();

		String type = request.getParameter("type");
		/******設定******/
		out.print("<option>");
		out.print("請選擇");
		out.print("</option>");

		//List<String> StandardSymptomsList = new ArrayList<String>();

		String sqlQuery = "SELECT * from text_to_standard_table WHERE (standard LIKE '%:"
				+ type + ":%')";
		ResultSet rs;
		rs = db.ExcuteQuery(sqlQuery);

		while (rs.next()) {

			try {
				out.print("<option value='"+rs.getString("text")+"'>");
				out.print(rs.getString("text"));
				out.print("</option>");
				//StandardSymptomsList.add(rs.getString("text"));

			} catch (SQLException e) {
				throw new SQLException(e);
			} // end try-catch
		}
	
		db.CloseConn();
	%>




</body>
</html>